-
Re: IF/OR Formula Issue with writing
Hi @Lydia Bowman, If your projects are being displayed on a single row, then you could use something like this: =IF(HAS([Add-ons]@row, "Prebill"), [Total Project Cost]@row - [Prebill Actual…1 · -
Re: Counting Blank Cells
If your cells are blank, then this should work: =COUNTIF({Status Blank}, "") However, this will also capture any blank rows (such as those at the bottom of your sheet, so I would use an alt…2 · -
Re: Using CountIfs for months and year
Hi @Hawk23, If you have helper columns for year/month in your first sheet (the sheet for the totals), you don't need them in the data sheet and can use the Created column for both. For example, with …1 · -
Re: Formula for text string
Hi @BullandKhmer, You can do this with a bunch of hidden columns, but you will also need to add some for where you have assessments on the same date (such as Dave in the example): Here the As1order-A…1 · -
Re: Index(Collect( Formula Help
Hi @SergeantPup, It should be something like this, using the (hopefully!) relevant column names in the cross sheet references: =INDEX(COLLECT({Team Capacity Points}, {Iteration Name}, [Iteration Name…1 ·